# coding=utf8
import sys

from openpyxl.reader.excel import load_workbook
from openpyxl.styles import Font, Border, Side

reload(sys)
sys.setdefaultencoding('utf-8')


def process(work_book):
    wb = load_workbook(filename=work_book)
    ws = wb.worksheets[0]
    font = Font(name=u'宋体', size=12)
    border = Border(left=Side(style='thin'),
                    right=Side(style='thin'),
                    top=Side(style='thin'),
                    bottom=Side(style='thin'))
    ws.sheet_view.zoomScale = 100
    cell = ws.cell(row=2, column=2)
    cell.font = font
    cell.border = border
    print ws.max_row
    for r in range(1, ws.max_row + 1):
        for i in range(1, ws.max_column + 1):
            cell = ws.cell(row=r, column=i)
            cell.value = None
            cell.border = border
    ws.print_area = 'A1:F%d' % (ws.max_row)
    print 'end.'
